package net.adetech.cjg.innerservice.mapper;

import net.adetech.cjg.innerservice.entity.Apk;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ApkDao {

    @Select("select * from cjg_apk where yxbz= '1' and (bblx='2' and dept_id like '%'||(select dept_id from CJG_ZD where ZDIP = #{ip})||'%') or bblx = '1' order by bbh desc,bblx desc")
    List<Apk> getUpdateApkListByIp(String ip);
}
